﻿CREATE TABLE [ccc].[Schools]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[SchoolType] [smallint] NOT NULL,
[SchoolName] [varchar] (100) NOT NULL,
[Address1] [varchar] (50) NOT NULL,
[Address2] [varchar] (50) NULL,
[Address3] [varchar] (50) NULL,
[Town] [varchar] (50) NOT NULL,
[County] [varchar] (50) NULL,
[PostCode] [varchar] (8) NOT NULL,
[SchoolTel] [varchar] (50) NOT NULL,
[ContactFirstName] [varchar] (50) NOT NULL,
[ContactLastName] [varchar] (50) NOT NULL,
[ContactEmail] [varchar] (50) NOT NULL,
[ContactTel] [varchar] (50) NULL,
[SecondaryContactName] [varchar] (50) NULL,
[Password] [varchar] (50) NOT NULL,
[Created] [DateTime] NOT NULL,
[LastUpdated] [DateTime] NOT NULL,
[ConcurencyId] RowVersion

) ON [PRIMARY]


